ISODATE

Returns the ISO date format (YYYY-MM-DD) for a given date.

Syntax

ISODATE(date)

Arguments

• date: The date to format in ISO format.

Example

ISODATE("3/2/2025") → Returns "2025-03-02T06:00:00.000Z"
ISODATE(A1) → Returns the ISO formatted date for the date in cell A1